package com.system.common.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BisShopExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BisShopExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andShopIdIsNull() {
            addCriterion("shop_id is null");
            return (Criteria) this;
        }

        public Criteria andShopIdIsNotNull() {
            addCriterion("shop_id is not null");
            return (Criteria) this;
        }

        public Criteria andShopIdEqualTo(String value) {
            addCriterion("shop_id =", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotEqualTo(String value) {
            addCriterion("shop_id <>", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdGreaterThan(String value) {
            addCriterion("shop_id >", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdGreaterThanOrEqualTo(String value) {
            addCriterion("shop_id >=", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLessThan(String value) {
            addCriterion("shop_id <", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLessThanOrEqualTo(String value) {
            addCriterion("shop_id <=", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLike(String value) {
            addCriterion("shop_id like", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotLike(String value) {
            addCriterion("shop_id not like", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdIn(List<String> values) {
            addCriterion("shop_id in", values, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotIn(List<String> values) {
            addCriterion("shop_id not in", values, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdBetween(String value1, String value2) {
            addCriterion("shop_id between", value1, value2, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotBetween(String value1, String value2) {
            addCriterion("shop_id not between", value1, value2, "shopId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdIsNull() {
            addCriterion("owner_id is null");
            return (Criteria) this;
        }

        public Criteria andOwnerIdIsNotNull() {
            addCriterion("owner_id is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerIdEqualTo(String value) {
            addCriterion("owner_id =", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotEqualTo(String value) {
            addCriterion("owner_id <>", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdGreaterThan(String value) {
            addCriterion("owner_id >", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdGreaterThanOrEqualTo(String value) {
            addCriterion("owner_id >=", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdLessThan(String value) {
            addCriterion("owner_id <", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdLessThanOrEqualTo(String value) {
            addCriterion("owner_id <=", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdLike(String value) {
            addCriterion("owner_id like", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotLike(String value) {
            addCriterion("owner_id not like", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdIn(List<String> values) {
            addCriterion("owner_id in", values, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotIn(List<String> values) {
            addCriterion("owner_id not in", values, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdBetween(String value1, String value2) {
            addCriterion("owner_id between", value1, value2, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotBetween(String value1, String value2) {
            addCriterion("owner_id not between", value1, value2, "ownerId");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNull() {
            addCriterion("shop_name is null");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNotNull() {
            addCriterion("shop_name is not null");
            return (Criteria) this;
        }

        public Criteria andShopNameEqualTo(String value) {
            addCriterion("shop_name =", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotEqualTo(String value) {
            addCriterion("shop_name <>", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThan(String value) {
            addCriterion("shop_name >", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThanOrEqualTo(String value) {
            addCriterion("shop_name >=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThan(String value) {
            addCriterion("shop_name <", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThanOrEqualTo(String value) {
            addCriterion("shop_name <=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLike(String value) {
            addCriterion("shop_name like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotLike(String value) {
            addCriterion("shop_name not like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameIn(List<String> values) {
            addCriterion("shop_name in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotIn(List<String> values) {
            addCriterion("shop_name not in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameBetween(String value1, String value2) {
            addCriterion("shop_name between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotBetween(String value1, String value2) {
            addCriterion("shop_name not between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNull() {
            addCriterion("short_name is null");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNotNull() {
            addCriterion("short_name is not null");
            return (Criteria) this;
        }

        public Criteria andShortNameEqualTo(String value) {
            addCriterion("short_name =", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotEqualTo(String value) {
            addCriterion("short_name <>", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThan(String value) {
            addCriterion("short_name >", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThanOrEqualTo(String value) {
            addCriterion("short_name >=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThan(String value) {
            addCriterion("short_name <", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThanOrEqualTo(String value) {
            addCriterion("short_name <=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLike(String value) {
            addCriterion("short_name like", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotLike(String value) {
            addCriterion("short_name not like", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameIn(List<String> values) {
            addCriterion("short_name in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotIn(List<String> values) {
            addCriterion("short_name not in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameBetween(String value1, String value2) {
            addCriterion("short_name between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotBetween(String value1, String value2) {
            addCriterion("short_name not between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andMonthCashInIsNull() {
            addCriterion("month_cash_in is null");
            return (Criteria) this;
        }

        public Criteria andMonthCashInIsNotNull() {
            addCriterion("month_cash_in is not null");
            return (Criteria) this;
        }

        public Criteria andMonthCashInEqualTo(Double value) {
            addCriterion("month_cash_in =", value, "monthCashIn");
            return (Criteria) this;
        }

        public Criteria andMonthCashInNotEqualTo(Double value) {
            addCriterion("month_cash_in <>", value, "monthCashIn");
            return (Criteria) this;
        }

        public Criteria andMonthCashInGreaterThan(Double value) {
            addCriterion("month_cash_in >", value, "monthCashIn");
            return (Criteria) this;
        }

        public Criteria andMonthCashInGreaterThanOrEqualTo(Double value) {
            addCriterion("month_cash_in >=", value, "monthCashIn");
            return (Criteria) this;
        }

        public Criteria andMonthCashInLessThan(Double value) {
            addCriterion("month_cash_in <", value, "monthCashIn");
            return (Criteria) this;
        }

        public Criteria andMonthCashInLessThanOrEqualTo(Double value) {
            addCriterion("month_cash_in <=", value, "monthCashIn");
            return (Criteria) this;
        }

        public Criteria andMonthCashInIn(List<Double> values) {
            addCriterion("month_cash_in in", values, "monthCashIn");
            return (Criteria) this;
        }

        public Criteria andMonthCashInNotIn(List<Double> values) {
            addCriterion("month_cash_in not in", values, "monthCashIn");
            return (Criteria) this;
        }

        public Criteria andMonthCashInBetween(Double value1, Double value2) {
            addCriterion("month_cash_in between", value1, value2, "monthCashIn");
            return (Criteria) this;
        }

        public Criteria andMonthCashInNotBetween(Double value1, Double value2) {
            addCriterion("month_cash_in not between", value1, value2, "monthCashIn");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInIsNull() {
            addCriterion("month_expend_in is null");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInIsNotNull() {
            addCriterion("month_expend_in is not null");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInEqualTo(Double value) {
            addCriterion("month_expend_in =", value, "monthExpendIn");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInNotEqualTo(Double value) {
            addCriterion("month_expend_in <>", value, "monthExpendIn");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInGreaterThan(Double value) {
            addCriterion("month_expend_in >", value, "monthExpendIn");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInGreaterThanOrEqualTo(Double value) {
            addCriterion("month_expend_in >=", value, "monthExpendIn");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInLessThan(Double value) {
            addCriterion("month_expend_in <", value, "monthExpendIn");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInLessThanOrEqualTo(Double value) {
            addCriterion("month_expend_in <=", value, "monthExpendIn");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInIn(List<Double> values) {
            addCriterion("month_expend_in in", values, "monthExpendIn");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInNotIn(List<Double> values) {
            addCriterion("month_expend_in not in", values, "monthExpendIn");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInBetween(Double value1, Double value2) {
            addCriterion("month_expend_in between", value1, value2, "monthExpendIn");
            return (Criteria) this;
        }

        public Criteria andMonthExpendInNotBetween(Double value1, Double value2) {
            addCriterion("month_expend_in not between", value1, value2, "monthExpendIn");
            return (Criteria) this;
        }

        public Criteria andShopLicenseIsNull() {
            addCriterion("shop_license is null");
            return (Criteria) this;
        }

        public Criteria andShopLicenseIsNotNull() {
            addCriterion("shop_license is not null");
            return (Criteria) this;
        }

        public Criteria andShopLicenseEqualTo(String value) {
            addCriterion("shop_license =", value, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseNotEqualTo(String value) {
            addCriterion("shop_license <>", value, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseGreaterThan(String value) {
            addCriterion("shop_license >", value, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseGreaterThanOrEqualTo(String value) {
            addCriterion("shop_license >=", value, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseLessThan(String value) {
            addCriterion("shop_license <", value, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseLessThanOrEqualTo(String value) {
            addCriterion("shop_license <=", value, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseLike(String value) {
            addCriterion("shop_license like", value, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseNotLike(String value) {
            addCriterion("shop_license not like", value, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseIn(List<String> values) {
            addCriterion("shop_license in", values, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseNotIn(List<String> values) {
            addCriterion("shop_license not in", values, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseBetween(String value1, String value2) {
            addCriterion("shop_license between", value1, value2, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopLicenseNotBetween(String value1, String value2) {
            addCriterion("shop_license not between", value1, value2, "shopLicense");
            return (Criteria) this;
        }

        public Criteria andShopImageIsNull() {
            addCriterion("shop_image is null");
            return (Criteria) this;
        }

        public Criteria andShopImageIsNotNull() {
            addCriterion("shop_image is not null");
            return (Criteria) this;
        }

        public Criteria andShopImageEqualTo(String value) {
            addCriterion("shop_image =", value, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageNotEqualTo(String value) {
            addCriterion("shop_image <>", value, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageGreaterThan(String value) {
            addCriterion("shop_image >", value, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageGreaterThanOrEqualTo(String value) {
            addCriterion("shop_image >=", value, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageLessThan(String value) {
            addCriterion("shop_image <", value, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageLessThanOrEqualTo(String value) {
            addCriterion("shop_image <=", value, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageLike(String value) {
            addCriterion("shop_image like", value, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageNotLike(String value) {
            addCriterion("shop_image not like", value, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageIn(List<String> values) {
            addCriterion("shop_image in", values, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageNotIn(List<String> values) {
            addCriterion("shop_image not in", values, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageBetween(String value1, String value2) {
            addCriterion("shop_image between", value1, value2, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopImageNotBetween(String value1, String value2) {
            addCriterion("shop_image not between", value1, value2, "shopImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageIsNull() {
            addCriterion("shop_detail_image is null");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageIsNotNull() {
            addCriterion("shop_detail_image is not null");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageEqualTo(String value) {
            addCriterion("shop_detail_image =", value, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageNotEqualTo(String value) {
            addCriterion("shop_detail_image <>", value, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageGreaterThan(String value) {
            addCriterion("shop_detail_image >", value, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageGreaterThanOrEqualTo(String value) {
            addCriterion("shop_detail_image >=", value, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageLessThan(String value) {
            addCriterion("shop_detail_image <", value, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageLessThanOrEqualTo(String value) {
            addCriterion("shop_detail_image <=", value, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageLike(String value) {
            addCriterion("shop_detail_image like", value, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageNotLike(String value) {
            addCriterion("shop_detail_image not like", value, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageIn(List<String> values) {
            addCriterion("shop_detail_image in", values, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageNotIn(List<String> values) {
            addCriterion("shop_detail_image not in", values, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageBetween(String value1, String value2) {
            addCriterion("shop_detail_image between", value1, value2, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andShopDetailImageNotBetween(String value1, String value2) {
            addCriterion("shop_detail_image not between", value1, value2, "shopDetailImage");
            return (Criteria) this;
        }

        public Criteria andGpsXIsNull() {
            addCriterion("gps_x is null");
            return (Criteria) this;
        }

        public Criteria andGpsXIsNotNull() {
            addCriterion("gps_x is not null");
            return (Criteria) this;
        }

        public Criteria andGpsXEqualTo(Double value) {
            addCriterion("gps_x =", value, "gpsX");
            return (Criteria) this;
        }

        public Criteria andGpsXNotEqualTo(Double value) {
            addCriterion("gps_x <>", value, "gpsX");
            return (Criteria) this;
        }

        public Criteria andGpsXGreaterThan(Double value) {
            addCriterion("gps_x >", value, "gpsX");
            return (Criteria) this;
        }

        public Criteria andGpsXGreaterThanOrEqualTo(Double value) {
            addCriterion("gps_x >=", value, "gpsX");
            return (Criteria) this;
        }

        public Criteria andGpsXLessThan(Double value) {
            addCriterion("gps_x <", value, "gpsX");
            return (Criteria) this;
        }

        public Criteria andGpsXLessThanOrEqualTo(Double value) {
            addCriterion("gps_x <=", value, "gpsX");
            return (Criteria) this;
        }

        public Criteria andGpsXIn(List<Double> values) {
            addCriterion("gps_x in", values, "gpsX");
            return (Criteria) this;
        }

        public Criteria andGpsXNotIn(List<Double> values) {
            addCriterion("gps_x not in", values, "gpsX");
            return (Criteria) this;
        }

        public Criteria andGpsXBetween(Double value1, Double value2) {
            addCriterion("gps_x between", value1, value2, "gpsX");
            return (Criteria) this;
        }

        public Criteria andGpsXNotBetween(Double value1, Double value2) {
            addCriterion("gps_x not between", value1, value2, "gpsX");
            return (Criteria) this;
        }

        public Criteria andGpsYIsNull() {
            addCriterion("gps_y is null");
            return (Criteria) this;
        }

        public Criteria andGpsYIsNotNull() {
            addCriterion("gps_y is not null");
            return (Criteria) this;
        }

        public Criteria andGpsYEqualTo(Double value) {
            addCriterion("gps_y =", value, "gpsY");
            return (Criteria) this;
        }

        public Criteria andGpsYNotEqualTo(Double value) {
            addCriterion("gps_y <>", value, "gpsY");
            return (Criteria) this;
        }

        public Criteria andGpsYGreaterThan(Double value) {
            addCriterion("gps_y >", value, "gpsY");
            return (Criteria) this;
        }

        public Criteria andGpsYGreaterThanOrEqualTo(Double value) {
            addCriterion("gps_y >=", value, "gpsY");
            return (Criteria) this;
        }

        public Criteria andGpsYLessThan(Double value) {
            addCriterion("gps_y <", value, "gpsY");
            return (Criteria) this;
        }

        public Criteria andGpsYLessThanOrEqualTo(Double value) {
            addCriterion("gps_y <=", value, "gpsY");
            return (Criteria) this;
        }

        public Criteria andGpsYIn(List<Double> values) {
            addCriterion("gps_y in", values, "gpsY");
            return (Criteria) this;
        }

        public Criteria andGpsYNotIn(List<Double> values) {
            addCriterion("gps_y not in", values, "gpsY");
            return (Criteria) this;
        }

        public Criteria andGpsYBetween(Double value1, Double value2) {
            addCriterion("gps_y between", value1, value2, "gpsY");
            return (Criteria) this;
        }

        public Criteria andGpsYNotBetween(Double value1, Double value2) {
            addCriterion("gps_y not between", value1, value2, "gpsY");
            return (Criteria) this;
        }

        public Criteria andSortNoIsNull() {
            addCriterion("sort_no is null");
            return (Criteria) this;
        }

        public Criteria andSortNoIsNotNull() {
            addCriterion("sort_no is not null");
            return (Criteria) this;
        }

        public Criteria andSortNoEqualTo(Integer value) {
            addCriterion("sort_no =", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoNotEqualTo(Integer value) {
            addCriterion("sort_no <>", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoGreaterThan(Integer value) {
            addCriterion("sort_no >", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoGreaterThanOrEqualTo(Integer value) {
            addCriterion("sort_no >=", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoLessThan(Integer value) {
            addCriterion("sort_no <", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoLessThanOrEqualTo(Integer value) {
            addCriterion("sort_no <=", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoIn(List<Integer> values) {
            addCriterion("sort_no in", values, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoNotIn(List<Integer> values) {
            addCriterion("sort_no not in", values, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoBetween(Integer value1, Integer value2) {
            addCriterion("sort_no between", value1, value2, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoNotBetween(Integer value1, Integer value2) {
            addCriterion("sort_no not between", value1, value2, "sortNo");
            return (Criteria) this;
        }

        public Criteria andShopAddressIsNull() {
            addCriterion("shop_address is null");
            return (Criteria) this;
        }

        public Criteria andShopAddressIsNotNull() {
            addCriterion("shop_address is not null");
            return (Criteria) this;
        }

        public Criteria andShopAddressEqualTo(String value) {
            addCriterion("shop_address =", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressNotEqualTo(String value) {
            addCriterion("shop_address <>", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressGreaterThan(String value) {
            addCriterion("shop_address >", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressGreaterThanOrEqualTo(String value) {
            addCriterion("shop_address >=", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressLessThan(String value) {
            addCriterion("shop_address <", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressLessThanOrEqualTo(String value) {
            addCriterion("shop_address <=", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressLike(String value) {
            addCriterion("shop_address like", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressNotLike(String value) {
            addCriterion("shop_address not like", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressIn(List<String> values) {
            addCriterion("shop_address in", values, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressNotIn(List<String> values) {
            addCriterion("shop_address not in", values, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressBetween(String value1, String value2) {
            addCriterion("shop_address between", value1, value2, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressNotBetween(String value1, String value2) {
            addCriterion("shop_address not between", value1, value2, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeIsNull() {
            addCriterion("shop_qrcode is null");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeIsNotNull() {
            addCriterion("shop_qrcode is not null");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeEqualTo(String value) {
            addCriterion("shop_qrcode =", value, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeNotEqualTo(String value) {
            addCriterion("shop_qrcode <>", value, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeGreaterThan(String value) {
            addCriterion("shop_qrcode >", value, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeGreaterThanOrEqualTo(String value) {
            addCriterion("shop_qrcode >=", value, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeLessThan(String value) {
            addCriterion("shop_qrcode <", value, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeLessThanOrEqualTo(String value) {
            addCriterion("shop_qrcode <=", value, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeLike(String value) {
            addCriterion("shop_qrcode like", value, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeNotLike(String value) {
            addCriterion("shop_qrcode not like", value, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeIn(List<String> values) {
            addCriterion("shop_qrcode in", values, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeNotIn(List<String> values) {
            addCriterion("shop_qrcode not in", values, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeBetween(String value1, String value2) {
            addCriterion("shop_qrcode between", value1, value2, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopQrcodeNotBetween(String value1, String value2) {
            addCriterion("shop_qrcode not between", value1, value2, "shopQrcode");
            return (Criteria) this;
        }

        public Criteria andShopPhoneIsNull() {
            addCriterion("shop_phone is null");
            return (Criteria) this;
        }

        public Criteria andShopPhoneIsNotNull() {
            addCriterion("shop_phone is not null");
            return (Criteria) this;
        }

        public Criteria andShopPhoneEqualTo(String value) {
            addCriterion("shop_phone =", value, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneNotEqualTo(String value) {
            addCriterion("shop_phone <>", value, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneGreaterThan(String value) {
            addCriterion("shop_phone >", value, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("shop_phone >=", value, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneLessThan(String value) {
            addCriterion("shop_phone <", value, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneLessThanOrEqualTo(String value) {
            addCriterion("shop_phone <=", value, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneLike(String value) {
            addCriterion("shop_phone like", value, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneNotLike(String value) {
            addCriterion("shop_phone not like", value, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneIn(List<String> values) {
            addCriterion("shop_phone in", values, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneNotIn(List<String> values) {
            addCriterion("shop_phone not in", values, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneBetween(String value1, String value2) {
            addCriterion("shop_phone between", value1, value2, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopPhoneNotBetween(String value1, String value2) {
            addCriterion("shop_phone not between", value1, value2, "shopPhone");
            return (Criteria) this;
        }

        public Criteria andShopAreaIsNull() {
            addCriterion("shop_area is null");
            return (Criteria) this;
        }

        public Criteria andShopAreaIsNotNull() {
            addCriterion("shop_area is not null");
            return (Criteria) this;
        }

        public Criteria andShopAreaEqualTo(Double value) {
            addCriterion("shop_area =", value, "shopArea");
            return (Criteria) this;
        }

        public Criteria andShopAreaNotEqualTo(Double value) {
            addCriterion("shop_area <>", value, "shopArea");
            return (Criteria) this;
        }

        public Criteria andShopAreaGreaterThan(Double value) {
            addCriterion("shop_area >", value, "shopArea");
            return (Criteria) this;
        }

        public Criteria andShopAreaGreaterThanOrEqualTo(Double value) {
            addCriterion("shop_area >=", value, "shopArea");
            return (Criteria) this;
        }

        public Criteria andShopAreaLessThan(Double value) {
            addCriterion("shop_area <", value, "shopArea");
            return (Criteria) this;
        }

        public Criteria andShopAreaLessThanOrEqualTo(Double value) {
            addCriterion("shop_area <=", value, "shopArea");
            return (Criteria) this;
        }

        public Criteria andShopAreaIn(List<Double> values) {
            addCriterion("shop_area in", values, "shopArea");
            return (Criteria) this;
        }

        public Criteria andShopAreaNotIn(List<Double> values) {
            addCriterion("shop_area not in", values, "shopArea");
            return (Criteria) this;
        }

        public Criteria andShopAreaBetween(Double value1, Double value2) {
            addCriterion("shop_area between", value1, value2, "shopArea");
            return (Criteria) this;
        }

        public Criteria andShopAreaNotBetween(Double value1, Double value2) {
            addCriterion("shop_area not between", value1, value2, "shopArea");
            return (Criteria) this;
        }

        public Criteria andShopProjectIsNull() {
            addCriterion("shop_project is null");
            return (Criteria) this;
        }

        public Criteria andShopProjectIsNotNull() {
            addCriterion("shop_project is not null");
            return (Criteria) this;
        }

        public Criteria andShopProjectEqualTo(String value) {
            addCriterion("shop_project =", value, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectNotEqualTo(String value) {
            addCriterion("shop_project <>", value, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectGreaterThan(String value) {
            addCriterion("shop_project >", value, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectGreaterThanOrEqualTo(String value) {
            addCriterion("shop_project >=", value, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectLessThan(String value) {
            addCriterion("shop_project <", value, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectLessThanOrEqualTo(String value) {
            addCriterion("shop_project <=", value, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectLike(String value) {
            addCriterion("shop_project like", value, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectNotLike(String value) {
            addCriterion("shop_project not like", value, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectIn(List<String> values) {
            addCriterion("shop_project in", values, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectNotIn(List<String> values) {
            addCriterion("shop_project not in", values, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectBetween(String value1, String value2) {
            addCriterion("shop_project between", value1, value2, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopProjectNotBetween(String value1, String value2) {
            addCriterion("shop_project not between", value1, value2, "shopProject");
            return (Criteria) this;
        }

        public Criteria andShopTypeIsNull() {
            addCriterion("shop_type is null");
            return (Criteria) this;
        }

        public Criteria andShopTypeIsNotNull() {
            addCriterion("shop_type is not null");
            return (Criteria) this;
        }

        public Criteria andShopTypeEqualTo(String value) {
            addCriterion("shop_type =", value, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeNotEqualTo(String value) {
            addCriterion("shop_type <>", value, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeGreaterThan(String value) {
            addCriterion("shop_type >", value, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeGreaterThanOrEqualTo(String value) {
            addCriterion("shop_type >=", value, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeLessThan(String value) {
            addCriterion("shop_type <", value, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeLessThanOrEqualTo(String value) {
            addCriterion("shop_type <=", value, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeLike(String value) {
            addCriterion("shop_type like", value, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeNotLike(String value) {
            addCriterion("shop_type not like", value, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeIn(List<String> values) {
            addCriterion("shop_type in", values, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeNotIn(List<String> values) {
            addCriterion("shop_type not in", values, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeBetween(String value1, String value2) {
            addCriterion("shop_type between", value1, value2, "shopType");
            return (Criteria) this;
        }

        public Criteria andShopTypeNotBetween(String value1, String value2) {
            addCriterion("shop_type not between", value1, value2, "shopType");
            return (Criteria) this;
        }

        public Criteria andShowStatusIsNull() {
            addCriterion("show_status is null");
            return (Criteria) this;
        }

        public Criteria andShowStatusIsNotNull() {
            addCriterion("show_status is not null");
            return (Criteria) this;
        }

        public Criteria andShowStatusEqualTo(String value) {
            addCriterion("show_status =", value, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusNotEqualTo(String value) {
            addCriterion("show_status <>", value, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusGreaterThan(String value) {
            addCriterion("show_status >", value, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusGreaterThanOrEqualTo(String value) {
            addCriterion("show_status >=", value, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusLessThan(String value) {
            addCriterion("show_status <", value, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusLessThanOrEqualTo(String value) {
            addCriterion("show_status <=", value, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusLike(String value) {
            addCriterion("show_status like", value, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusNotLike(String value) {
            addCriterion("show_status not like", value, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusIn(List<String> values) {
            addCriterion("show_status in", values, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusNotIn(List<String> values) {
            addCriterion("show_status not in", values, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusBetween(String value1, String value2) {
            addCriterion("show_status between", value1, value2, "showStatus");
            return (Criteria) this;
        }

        public Criteria andShowStatusNotBetween(String value1, String value2) {
            addCriterion("show_status not between", value1, value2, "showStatus");
            return (Criteria) this;
        }

        public Criteria andIsDelIsNull() {
            addCriterion("is_del is null");
            return (Criteria) this;
        }

        public Criteria andIsDelIsNotNull() {
            addCriterion("is_del is not null");
            return (Criteria) this;
        }

        public Criteria andIsDelEqualTo(String value) {
            addCriterion("is_del =", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotEqualTo(String value) {
            addCriterion("is_del <>", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelGreaterThan(String value) {
            addCriterion("is_del >", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelGreaterThanOrEqualTo(String value) {
            addCriterion("is_del >=", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLessThan(String value) {
            addCriterion("is_del <", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLessThanOrEqualTo(String value) {
            addCriterion("is_del <=", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLike(String value) {
            addCriterion("is_del like", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotLike(String value) {
            addCriterion("is_del not like", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelIn(List<String> values) {
            addCriterion("is_del in", values, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotIn(List<String> values) {
            addCriterion("is_del not in", values, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelBetween(String value1, String value2) {
            addCriterion("is_del between", value1, value2, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotBetween(String value1, String value2) {
            addCriterion("is_del not between", value1, value2, "isDel");
            return (Criteria) this;
        }

        public Criteria andShopRemarkIsNull() {
            addCriterion("shop_remark is null");
            return (Criteria) this;
        }

        public Criteria andShopRemarkIsNotNull() {
            addCriterion("shop_remark is not null");
            return (Criteria) this;
        }

        public Criteria andShopRemarkEqualTo(String value) {
            addCriterion("shop_remark =", value, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkNotEqualTo(String value) {
            addCriterion("shop_remark <>", value, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkGreaterThan(String value) {
            addCriterion("shop_remark >", value, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("shop_remark >=", value, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkLessThan(String value) {
            addCriterion("shop_remark <", value, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkLessThanOrEqualTo(String value) {
            addCriterion("shop_remark <=", value, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkLike(String value) {
            addCriterion("shop_remark like", value, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkNotLike(String value) {
            addCriterion("shop_remark not like", value, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkIn(List<String> values) {
            addCriterion("shop_remark in", values, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkNotIn(List<String> values) {
            addCriterion("shop_remark not in", values, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkBetween(String value1, String value2) {
            addCriterion("shop_remark between", value1, value2, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andShopRemarkNotBetween(String value1, String value2) {
            addCriterion("shop_remark not between", value1, value2, "shopRemark");
            return (Criteria) this;
        }

        public Criteria andBeginTimeIsNull() {
            addCriterion("begin_time is null");
            return (Criteria) this;
        }

        public Criteria andBeginTimeIsNotNull() {
            addCriterion("begin_time is not null");
            return (Criteria) this;
        }

        public Criteria andBeginTimeEqualTo(String value) {
            addCriterion("begin_time =", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeNotEqualTo(String value) {
            addCriterion("begin_time <>", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeGreaterThan(String value) {
            addCriterion("begin_time >", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeGreaterThanOrEqualTo(String value) {
            addCriterion("begin_time >=", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeLessThan(String value) {
            addCriterion("begin_time <", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeLessThanOrEqualTo(String value) {
            addCriterion("begin_time <=", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeLike(String value) {
            addCriterion("begin_time like", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeNotLike(String value) {
            addCriterion("begin_time not like", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeIn(List<String> values) {
            addCriterion("begin_time in", values, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeNotIn(List<String> values) {
            addCriterion("begin_time not in", values, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeBetween(String value1, String value2) {
            addCriterion("begin_time between", value1, value2, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeNotBetween(String value1, String value2) {
            addCriterion("begin_time not between", value1, value2, "beginTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(String value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(String value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(String value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(String value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(String value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(String value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLike(String value) {
            addCriterion("end_time like", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotLike(String value) {
            addCriterion("end_time not like", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<String> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<String> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(String value1, String value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(String value1, String value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNull() {
            addCriterion("create_user_id is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNotNull() {
            addCriterion("create_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdEqualTo(String value) {
            addCriterion("create_user_id =", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotEqualTo(String value) {
            addCriterion("create_user_id <>", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThan(String value) {
            addCriterion("create_user_id >", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_user_id >=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThan(String value) {
            addCriterion("create_user_id <", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThanOrEqualTo(String value) {
            addCriterion("create_user_id <=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLike(String value) {
            addCriterion("create_user_id like", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotLike(String value) {
            addCriterion("create_user_id not like", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIn(List<String> values) {
            addCriterion("create_user_id in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotIn(List<String> values) {
            addCriterion("create_user_id not in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdBetween(String value1, String value2) {
            addCriterion("create_user_id between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotBetween(String value1, String value2) {
            addCriterion("create_user_id not between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIsNull() {
            addCriterion("modify_time is null");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIsNotNull() {
            addCriterion("modify_time is not null");
            return (Criteria) this;
        }

        public Criteria andModifyTimeEqualTo(Date value) {
            addCriterion("modify_time =", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotEqualTo(Date value) {
            addCriterion("modify_time <>", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeGreaterThan(Date value) {
            addCriterion("modify_time >", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("modify_time >=", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLessThan(Date value) {
            addCriterion("modify_time <", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLessThanOrEqualTo(Date value) {
            addCriterion("modify_time <=", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIn(List<Date> values) {
            addCriterion("modify_time in", values, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotIn(List<Date> values) {
            addCriterion("modify_time not in", values, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeBetween(Date value1, Date value2) {
            addCriterion("modify_time between", value1, value2, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotBetween(Date value1, Date value2) {
            addCriterion("modify_time not between", value1, value2, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdIsNull() {
            addCriterion("modify_user_id is null");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdIsNotNull() {
            addCriterion("modify_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdEqualTo(String value) {
            addCriterion("modify_user_id =", value, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdNotEqualTo(String value) {
            addCriterion("modify_user_id <>", value, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdGreaterThan(String value) {
            addCriterion("modify_user_id >", value, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("modify_user_id >=", value, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdLessThan(String value) {
            addCriterion("modify_user_id <", value, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdLessThanOrEqualTo(String value) {
            addCriterion("modify_user_id <=", value, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdLike(String value) {
            addCriterion("modify_user_id like", value, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdNotLike(String value) {
            addCriterion("modify_user_id not like", value, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdIn(List<String> values) {
            addCriterion("modify_user_id in", values, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdNotIn(List<String> values) {
            addCriterion("modify_user_id not in", values, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdBetween(String value1, String value2) {
            addCriterion("modify_user_id between", value1, value2, "modifyUserId");
            return (Criteria) this;
        }

        public Criteria andModifyUserIdNotBetween(String value1, String value2) {
            addCriterion("modify_user_id not between", value1, value2, "modifyUserId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}